USE [NLKHCNData]
print 'Update view DeTaiCapTinhView'
GO

ALTER VIEW [dbo].[DeTaiCapTinhView]
AS
SELECT        dbo.DeTaiCapTinh.ChuyenGiaId, dbo.DeTaiCapTinh.TenDeTai, dbo.DeTaiCapTinh.NamThucHien, dbo.DeTaiCapTinh.TacGia, 
                         dbo.TinhThanhPho.Ten AS TenTinhThanhPho
FROM            dbo.DeTaiCapTinh LEFT OUTER JOIN
                         dbo.TinhThanhPho ON dbo.DeTaiCapTinh.TinhThanhPhoId = dbo.TinhThanhPho.Id

GO


